Step by Step Instructions to reproduce solution from scratch 8

 Step by Step Instructions to reproduce solution from scratch

https://1drv.ms/u/s!AqynLAPPbtjviP1M22nlf-9p0L0LXg?e=C2gzpe  

·             LOAD DATA INTO POWER BI

    


    Create Association Between The Tables

 Follow the instructions below to create  association between the Fact Table and the Dimension Tables.

  1. Click on model tab to begin creating association
  2. Drag Status Key Column in  Dim_Status Table to join Status Key Column in Facts_Zendesk Table to create Associate between the 2 tables

  3. Repeat the same process by dragging and  joining common columns between Dim_Agent,Dim_Ticket, Dim_Channel and Facts_Zendesk Tables to Create association between them.
  4. Drag the date Column in the Date table to join the Date Column  in Dim_ticket
  5.  



Step by Step Instructions to reproduce solution from scratch 8

 Step by Step Instructions to reproduce solution from scratch

https://1drv.ms/u/s!AqynLAPPbtjviP1M22nlf-9p0L0LXg?e=C2gzpe  

·             LOAD DATA INTO POWER BI

    


    Create Association Between The Tables

 Follow the instructions below to create  association between the Fact Table and the Dimension Tables.

  1. Click on model tab to begin creating association
  2. Drag Status Key Column in  Dim_Status Table to join Status Key Column in Facts_Zendesk Table to create Associate between the 2 tables

  3. Repeat the same process by dragging and  joining common columns between Dim_Agent,Dim_Ticket, Dim_Channel and Facts_Zendesk Tables to Create association between them.
  4. Drag the date Column in the Date table to join the Date Column  in Dim_ticket
  5.